﻿CREATE TABLE [Sales].[PartitionTestNCPK] (
    [PTID]   INT      NOT NULL,
    [PTDate] DATETIME NOT NULL,
    CONSTRAINT [PK_PartitionTestNCPK] PRIMARY KEY NONCLUSTERED ([PTID] ASC, [PTDate] ASC) ON [psPartitionTestNCPK] ([PTDate])
);


GO
CREATE CLUSTERED INDEX [IDX_PartitionTestNCPK_Clustered]
    ON [Sales].[PartitionTestNCPK]([PTDate] ASC, [PTID] ASC)
    ON [psPartitionTestNCPK] ([PTDate]);

